The Case for an Agri Data Warehouse: Enabling Analytical Exploration of Integrated Agricultural Data
نویسندگان
چکیده
First step towards understanding any agricultural system is the comprehension of relationships between the system and numerous physical, chemical and biological factors influencing it. Any decision regarding such systems requires analytical exploration of the involved data. The exploration task is to be supported by an efficient data storage and retrieval mechanism. In this paper we have presented the case of an Agri data warehouse for this purpose. We have briefly discussed the process we adopted for establishing the data warehouse encompassing pest, pesticide and metrological data. We have also shown how implementing an OLAP tool on top of the Agri data warehouse resulted in interesting findings from a decision support point of view.
منابع مشابه
Integrated Pest Management Farmer Field School for Sustainable Agriculture
The study was conducted among the two farmer groups in Bhaktapur and Kavre districts of Nepal. The main objective of the study is to evaluate the effectiveness of IPM FFS on creating awareness and disseminating the knowledge on sustainable pest management to the farmers and to assess the relationships between enhanced IPM knowledge and adoption of IPM strategies by the farmers. The study has be...
متن کاملFarmers Perception about gains from Integrated Pest Management Farmer Field School
The study was conducted among the two farmer groups in Bhaktapur and Kavre districts of Nepal. The main objective of the study is to evaluate the differences in belief, attitude and practices felt by the farmers after participation in the IPM FFS. The study has been based on data collected through personal interview with the farmers, focus group discussion, personal observation in the farmers f...
متن کاملارائه مدل تلفیقی برای ارزیابی آمادگی سازمان ها جهت پیاده سازی سیستم انباره داده با استفاده ازتحلیل سلسله مراتبی
Enterprise Data Warehouse initiative is a high investment project. The adoption of Data Warehouse will be significantly different depending upon the level of readiness of an organization. Before implementation of Data Warehouse system in a firm, it is necessary to evaluate the level of the readiness of firm. A successful Data Warehouse assessment model requires a deep understanding of opportuni...
متن کاملImprovement of the Analytical Queries Response Time in Real-Time Data Warehouse using Materialized Views Concatenation
A real-time data warehouse is a collection of recent and hierarchical data that is used for managers’ decision-making by creating online analytical queries. The volume of data collected from data sources and entered into the real-time data warehouse is constantly increasing. Moreover, as the volume of input data to the real time data warehouse increases, the interference between online loading ...
متن کاملAn Online Analytical Processing (OLAP) Database for Agricultural Policy Data: a Greek Case Study
Statistical data for agricultural policy analysis has certain unique features: a multitude of sources of very different nature; a variety of dimensional granularity; different end user requirements. The utilization of Data Warehouse technology would be valuable for overcoming the above data issues. Ιn this paper, we describe the technologies involved and the data modeling requirements, making a...
متن کامل